/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : 127.0.0.1:3306
 Source Schema         : ndmall_oms

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 25/06/2023 11:03:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for branch_table
-- ----------------------------
DROP TABLE IF EXISTS `branch_table`;
CREATE TABLE `branch_table` (
  `branch_id` bigint(20) NOT NULL,
  `xid` varchar(128) NOT NULL,
  `transaction_id` bigint(20) DEFAULT NULL,
  `resource_group_id` varchar(32) DEFAULT NULL,
  `resource_id` varchar(256) DEFAULT NULL,
  `branch_type` varchar(8) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `client_id` varchar(64) DEFAULT NULL,
  `application_data` varchar(2000) DEFAULT NULL,
  `gmt_create` datetime(6) DEFAULT NULL,
  `gmt_modified` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`branch_id`),
  KEY `idx_xid` (`xid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for global_table
-- ----------------------------
DROP TABLE IF EXISTS `global_table`;
CREATE TABLE `global_table` (
  `xid` varchar(128) NOT NULL,
  `transaction_id` bigint(20) DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `application_id` varchar(32) DEFAULT NULL,
  `transaction_service_group` varchar(32) DEFAULT NULL,
  `transaction_name` varchar(128) DEFAULT NULL,
  `timeout` int(11) DEFAULT NULL,
  `begin_time` bigint(20) DEFAULT NULL,
  `application_data` varchar(2000) DEFAULT NULL,
  `gmt_create` datetime DEFAULT NULL,
  `gmt_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`xid`),
  KEY `idx_gmt_modified_status` (`gmt_modified`,`status`),
  KEY `idx_transaction_id` (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for lock_table
-- ----------------------------
DROP TABLE IF EXISTS `lock_table`;
CREATE TABLE `lock_table` (
  `row_key` varchar(128) NOT NULL,
  `xid` varchar(96) DEFAULT NULL,
  `transaction_id` bigint(20) DEFAULT NULL,
  `branch_id` bigint(20) NOT NULL,
  `resource_id` varchar(256) DEFAULT NULL,
  `table_name` varchar(32) DEFAULT NULL,
  `pk` varchar(36) DEFAULT NULL,
  `gmt_create` datetime DEFAULT NULL,
  `gmt_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`row_key`),
  KEY `idx_branch_id` (`branch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for oms_cart
-- ----------------------------
DROP TABLE IF EXISTS `oms_cart`;
CREATE TABLE `oms_cart` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) DEFAULT NULL COMMENT '用户表的用户ID',
  `goods_id` int(10) DEFAULT NULL COMMENT '商品表的商品ID',
  `goods_sn` varchar(63) DEFAULT NULL COMMENT '商品编号',
  `goods_name` varchar(127) DEFAULT NULL COMMENT '商品名称',
  `product_id` int(10) DEFAULT NULL COMMENT '商品货品表的货品ID',
  `price` decimal(10,2) DEFAULT NULL COMMENT '商品货品的价格',
  `number` smallint(5) DEFAULT NULL COMMENT '商品货品的数量',
  `specifications` varchar(1023) DEFAULT NULL COMMENT '商品规格值列表，采用JSON数组格式',
  `checked` bit(1) DEFAULT NULL COMMENT '购物车中商品是否选择状态',
  `pic_url` varchar(255) DEFAULT NULL COMMENT '商品图片或者商品货品图片',
  `add_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` bit(1) DEFAULT b'0' COMMENT '逻辑删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=364527712 DEFAULT CHARSET=utf8mb4 COMMENT='购物车商品表';

-- ----------------------------
-- Records of oms_cart
-- ----------------------------
BEGIN;
INSERT INTO `oms_cart` VALUES (2, 3, 1039051, '1039051', '多功能午睡枕', 54, 79.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/c8ca0600fa7ba11ca8be6a3173dd38c9.png', '2020-06-27 18:42:55', '2020-06-27 18:42:55', b'1');
INSERT INTO `oms_cart` VALUES (3, 3, 1181000, '1181000', '母亲节礼物-舒适安睡组合', 2, 1500.00, 1, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', b'1', 'quality=90&thumbnail=200x200&imageView', '2020-06-27 18:46:44', '2020-06-27 18:46:44', b'1');
INSERT INTO `oms_cart` VALUES (4, 3, 1039051, '1039051', '多功能午睡枕', 54, 79.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/c8ca0600fa7ba11ca8be6a3173dd38c9.png', '2020-07-01 20:54:48', '2020-07-01 20:54:48', b'1');
INSERT INTO `oms_cart` VALUES (5, 3, 1181001, '1001991', '新梦想睡枕', 246, 89.00, 1, '[\"灰色\",\"1.5\"]', b'1', 'https://app-newdream-1302590708.cos.ap-shanghai.myqcloud.com/ovwr2niit6a9jrp7xurn.png', '2020-07-08 11:08:08', '2020-07-08 11:08:08', b'1');
INSERT INTO `oms_cart` VALUES (6, 3, 1181001, '1001991', '新梦想睡枕', 248, 10.00, 11, '[\"红色\",\"1.5\"]', b'1', 'https://app-newdream-1302590708.cos.ap-shanghai.myqcloud.com/ovwr2niit6a9jrp7xurn.png', '2020-07-08 11:42:47', '2020-07-23 20:45:13', b'1');
INSERT INTO `oms_cart` VALUES (7, 3, 1130037, '1130037', '帆布丝羽绒多用坐垫', 189, 39.00, 3, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/19ecd7c6f6f31219cf75117238d95139.png', '2020-07-21 11:27:42', '2020-07-21 11:27:49', b'1');
INSERT INTO `oms_cart` VALUES (13, 1, 1181000, '1181000', '母亲节礼物-舒适安睡组合', 2, 1500.00, 1, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', b'1', 'quality=90&thumbnail=200x200&imageView', '2020-07-23 17:03:05', '2020-07-23 17:03:05', b'1');
INSERT INTO `oms_cart` VALUES (33, 1, 1006013, '1006013', '双宫茧桑蚕丝被 空调被', 10, 699.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/583812520c68ca7995b6fac4c67ae2c7.png', '2021-08-26 17:20:40', '2021-08-26 17:20:40', b'1');
INSERT INTO `oms_cart` VALUES (34, 1, 1152161, '1152161', '竹语丝麻印花四件套', 239, 459.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/977401e75113f7c8334c4fb5b4bf6215.png', '2021-08-26 17:35:15', '2021-08-26 17:35:15', b'1');
INSERT INTO `oms_cart` VALUES (35, 1, 1006007, '1006007', '秋冬保暖加厚澳洲羊毛被', 8, 459.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/66425d1ed50b3968fed27c822fdd32e0.png', '2021-08-26 17:36:23', '2021-08-26 17:36:23', b'1');
INSERT INTO `oms_cart` VALUES (36, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-26 20:31:27', '2021-08-26 20:31:27', b'1');
INSERT INTO `oms_cart` VALUES (37, 1, 1009012, '1009012', '可水洗舒柔丝羽绒枕', 14, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/a196b367f23ccfd8205b6da647c62b84.png', '2021-08-26 20:39:30', '2021-08-26 20:39:30', b'1');
INSERT INTO `oms_cart` VALUES (38, 1, 1110018, '1110018', '耐用狗狗清洁美容护理套装', 152, 79.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/d93aa5d6e7a296101cf4cb72613aeda6.png', '2021-08-26 21:33:06', '2021-08-26 21:33:06', b'1');
INSERT INTO `oms_cart` VALUES (39, 1, 1006013, '1006013', '双宫茧桑蚕丝被 空调被', 10, 699.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/583812520c68ca7995b6fac4c67ae2c7.png', '2021-08-26 21:48:05', '2021-08-26 21:48:05', b'1');
INSERT INTO `oms_cart` VALUES (40, 1, 1006007, '1006007', '秋冬保暖加厚澳洲羊毛被', 8, 459.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/66425d1ed50b3968fed27c822fdd32e0.png', '2021-08-26 22:13:27', '2021-08-26 22:13:27', b'1');
INSERT INTO `oms_cart` VALUES (41, 1, 1127047, '1127047', '趣味粉彩系列笔记本', 182, 29.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/6c03ca93d8fe404faa266ea86f3f1e43.png', '2021-08-26 22:23:58', '2021-08-26 22:23:58', b'1');
INSERT INTO `oms_cart` VALUES (42, 1, 1006007, '1006007', '秋冬保暖加厚澳洲羊毛被', 8, 459.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/66425d1ed50b3968fed27c822fdd32e0.png', '2021-08-26 22:32:55', '2021-08-26 22:32:55', b'1');
INSERT INTO `oms_cart` VALUES (43, 1, 1006013, '1006013', '双宫茧桑蚕丝被 空调被', 10, 699.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/583812520c68ca7995b6fac4c67ae2c7.png', '2021-08-27 14:20:46', '2021-08-27 14:20:46', b'1');
INSERT INTO `oms_cart` VALUES (44, 1, 1006013, '1006013', '双宫茧桑蚕丝被 空调被', 10, 699.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/583812520c68ca7995b6fac4c67ae2c7.png', '2021-08-27 14:22:01', '2021-08-27 14:22:01', b'1');
INSERT INTO `oms_cart` VALUES (45, 1, 1181001, '1001991', '新梦想睡枕22', 264, 10.00, 1, '[\"红色\",\"1.5\"]', b'1', 'https://app-newdream-1302590708.cos.ap-shanghai.myqcloud.com/ovwr2niit6a9jrp7xurn.png', '2021-08-27 14:36:11', '2021-08-27 14:36:11', b'1');
INSERT INTO `oms_cart` VALUES (46, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-27 14:42:14', '2021-08-27 14:42:14', b'1');
INSERT INTO `oms_cart` VALUES (47, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-27 15:07:11', '2021-08-27 15:07:11', b'1');
INSERT INTO `oms_cart` VALUES (48, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-27 15:44:52', '2021-08-27 15:44:52', b'1');
INSERT INTO `oms_cart` VALUES (49, 1, 1009012, '1009012', '可水洗舒柔丝羽绒枕', 14, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/a196b367f23ccfd8205b6da647c62b84.png', '2021-08-27 16:52:15', '2021-08-27 16:52:15', b'1');
INSERT INTO `oms_cart` VALUES (50, 1, 1006013, '1006013', '双宫茧桑蚕丝被 空调被', 10, 699.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/583812520c68ca7995b6fac4c67ae2c7.png', '2021-08-29 13:19:08', '2021-08-29 13:19:08', b'1');
INSERT INTO `oms_cart` VALUES (51, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-29 13:32:15', '2021-08-29 13:32:15', b'1');
INSERT INTO `oms_cart` VALUES (52, 1, 1009012, '1009012', '可水洗舒柔丝羽绒枕', 14, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/a196b367f23ccfd8205b6da647c62b84.png', '2021-08-29 13:48:00', '2021-08-29 13:48:00', b'1');
INSERT INTO `oms_cart` VALUES (53, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-29 14:11:29', '2021-08-29 14:11:29', b'1');
INSERT INTO `oms_cart` VALUES (54, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-29 14:16:17', '2021-08-29 14:16:17', b'1');
INSERT INTO `oms_cart` VALUES (55, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-29 14:20:58', '2021-08-29 14:20:58', b'1');
INSERT INTO `oms_cart` VALUES (56, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-29 17:10:59', '2021-08-29 17:10:59', b'1');
INSERT INTO `oms_cart` VALUES (57, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-29 17:10:59', '2021-08-29 17:10:59', b'1');
INSERT INTO `oms_cart` VALUES (58, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-29 17:12:43', '2021-08-29 17:12:43', b'1');
INSERT INTO `oms_cart` VALUES (59, 1, 1009012, '1009012', '可水洗舒柔丝羽绒枕', 14, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/a196b367f23ccfd8205b6da647c62b84.png', '2021-08-29 17:22:06', '2021-08-29 17:22:06', b'1');
INSERT INTO `oms_cart` VALUES (60, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-30 11:33:29', '2021-08-30 11:33:29', b'1');
INSERT INTO `oms_cart` VALUES (61, 1, 1009012, '1009012', '可水洗舒柔丝羽绒枕', 14, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/a196b367f23ccfd8205b6da647c62b84.png', '2021-08-30 11:36:33', '2021-08-30 11:36:33', b'1');
INSERT INTO `oms_cart` VALUES (62, 1, 1009012, '1009012', '可水洗舒柔丝羽绒枕', 14, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/a196b367f23ccfd8205b6da647c62b84.png', '2021-08-30 11:38:05', '2021-08-30 11:38:05', b'1');
INSERT INTO `oms_cart` VALUES (63, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-30 22:13:59', '2021-08-30 22:13:59', b'1');
INSERT INTO `oms_cart` VALUES (64, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-30 22:13:59', '2021-08-30 22:13:59', b'1');
INSERT INTO `oms_cart` VALUES (65, 1, 1127047, '1127047', '趣味粉彩系列笔记本', 182, 29.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/6c03ca93d8fe404faa266ea86f3f1e43.png', '2021-08-30 22:14:51', '2021-08-30 22:14:51', b'1');
INSERT INTO `oms_cart` VALUES (66, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-30 22:20:30', '2021-08-30 22:20:30', b'1');
INSERT INTO `oms_cart` VALUES (67, 1, 1127047, '1127047', '趣味粉彩系列笔记本', 182, 29.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/6c03ca93d8fe404faa266ea86f3f1e43.png', '2021-08-30 22:37:21', '2021-08-30 22:37:21', b'1');
INSERT INTO `oms_cart` VALUES (68, 1, 1127047, '1127047', '趣味粉彩系列笔记本', 182, 29.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/6c03ca93d8fe404faa266ea86f3f1e43.png', '2021-08-30 22:40:22', '2021-08-30 22:40:22', b'1');
INSERT INTO `oms_cart` VALUES (69, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-30 22:41:08', '2021-08-30 22:41:08', b'1');
INSERT INTO `oms_cart` VALUES (70, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-30 22:43:31', '2021-08-30 22:43:31', b'1');
INSERT INTO `oms_cart` VALUES (71, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 12:35:42', '2021-08-31 12:35:42', b'1');
INSERT INTO `oms_cart` VALUES (72, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 12:41:22', '2021-08-31 12:41:22', b'1');
INSERT INTO `oms_cart` VALUES (73, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 12:43:42', '2021-08-31 12:43:42', b'1');
INSERT INTO `oms_cart` VALUES (74, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 12:45:24', '2021-08-31 12:45:24', b'1');
INSERT INTO `oms_cart` VALUES (75, 1, 1006013, '1006013', '双宫茧桑蚕丝被 空调被', 10, 699.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/583812520c68ca7995b6fac4c67ae2c7.png', '2021-08-31 12:53:20', '2021-08-31 12:53:20', b'1');
INSERT INTO `oms_cart` VALUES (76, 1, 1006013, '1006013', '双宫茧桑蚕丝被 空调被', 10, 699.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/583812520c68ca7995b6fac4c67ae2c7.png', '2021-08-31 12:53:34', '2021-08-31 12:53:34', b'1');
INSERT INTO `oms_cart` VALUES (77, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 14:47:54', '2021-08-31 14:47:54', b'1');
INSERT INTO `oms_cart` VALUES (78, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 14:48:24', '2021-08-31 14:48:24', b'1');
INSERT INTO `oms_cart` VALUES (79, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 14:52:05', '2021-08-31 14:52:05', b'1');
INSERT INTO `oms_cart` VALUES (80, 1, 1127047, '1127047', '趣味粉彩系列笔记本', 182, 29.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/6c03ca93d8fe404faa266ea86f3f1e43.png', '2021-08-31 14:53:10', '2021-08-31 14:53:10', b'1');
INSERT INTO `oms_cart` VALUES (81, 1, 1127047, '1127047', '趣味粉彩系列笔记本', 182, 29.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/6c03ca93d8fe404faa266ea86f3f1e43.png', '2021-08-31 14:53:22', '2021-08-31 14:53:22', b'1');
INSERT INTO `oms_cart` VALUES (82, 1, 1127047, '1127047', '趣味粉彩系列笔记本', 182, 29.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/6c03ca93d8fe404faa266ea86f3f1e43.png', '2021-08-31 14:54:07', '2021-08-31 14:54:07', b'1');
INSERT INTO `oms_cart` VALUES (83, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 15:05:16', '2021-08-31 15:05:16', b'1');
INSERT INTO `oms_cart` VALUES (84, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 15:05:49', '2021-08-31 15:05:49', b'1');
INSERT INTO `oms_cart` VALUES (85, 1, 1009012, '1009012', '可水洗舒柔丝羽绒枕', 14, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/a196b367f23ccfd8205b6da647c62b84.png', '2021-08-31 22:50:38', '2021-08-31 22:50:38', b'1');
INSERT INTO `oms_cart` VALUES (86, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 23:05:03', '2021-08-31 23:05:03', b'1');
INSERT INTO `oms_cart` VALUES (87, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 23:13:10', '2021-08-31 23:13:10', b'1');
INSERT INTO `oms_cart` VALUES (88, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 23:21:44', '2021-08-31 23:21:44', b'1');
INSERT INTO `oms_cart` VALUES (89, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 23:26:15', '2021-08-31 23:26:15', b'1');
INSERT INTO `oms_cart` VALUES (90, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 23:26:43', '2021-08-31 23:26:43', b'1');
INSERT INTO `oms_cart` VALUES (91, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 23:27:33', '2021-08-31 23:27:33', b'1');
INSERT INTO `oms_cart` VALUES (92, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-08-31 23:30:40', '2021-08-31 23:30:40', b'1');
INSERT INTO `oms_cart` VALUES (93, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-09-01 14:51:03', '2021-09-01 14:51:03', b'1');
INSERT INTO `oms_cart` VALUES (94, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-09-01 14:56:50', '2021-09-01 14:56:50', b'1');
INSERT INTO `oms_cart` VALUES (95, 1, 1009012, '1009012', '可水洗舒柔丝羽绒枕', 14, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/a196b367f23ccfd8205b6da647c62b84.png', '2021-09-02 10:04:06', '2021-09-02 10:04:06', b'1');
INSERT INTO `oms_cart` VALUES (96, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-09-02 15:16:24', '2021-09-02 15:16:24', b'1');
INSERT INTO `oms_cart` VALUES (97, 1, 1006051, '1006051', '皇室御用超柔毛巾', 12, 59.00, 1, '[标准]', b'1', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', '2021-09-03 15:26:23', '2021-09-03 15:26:23', b'1');
INSERT INTO `oms_cart` VALUES (98, 1, 1009012, '1009012', '可水洗舒柔丝羽绒枕', 14, 59.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/a196b367f23ccfd8205b6da647c62b84.png', '2021-09-04 20:39:47', '2021-09-04 20:39:47', b'1');
INSERT INTO `oms_cart` VALUES (364527703, 4, 1135072, '1135072', '经典海魂纹水手裙（婴童）', 215, 69.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/43e57d4208cdc78ac9c088f9b3e798f5.png', '2022-12-27 17:24:34', '2022-12-27 17:28:26', b'1');
INSERT INTO `oms_cart` VALUES (364527704, 4, 1181000, '1181000', '母亲节礼物-舒适安睡组合', 3, 1000.00, 1, '[\"1.5m床垫*1+枕头*2\",\"烟白灰\"]', b'1', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', '2022-12-28 11:42:17', '2022-12-28 11:42:17', b'1');
INSERT INTO `oms_cart` VALUES (364527705, 4, 1135073, '1135073', '海魂纹哈衣水手服（婴童）', 216, 69.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/53052b04ae001d289c040e09ea92231c.png', '2023-04-11 20:42:54', '2023-04-11 23:12:41', b'1');
INSERT INTO `oms_cart` VALUES (364527709, 4, 1135002, '1135002', '宫廷奢华真丝四件套', 204, 2599.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/45548f26cfd0c7c41e0afc3709d48286.png', '2023-05-27 11:46:32', '2023-05-27 12:14:10', b'1');
INSERT INTO `oms_cart` VALUES (364527710, 4, 1135002, '1135002', '宫廷奢华真丝四件套', 204, 2599.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/45548f26cfd0c7c41e0afc3709d48286.png', '2023-05-27 22:07:35', '2023-05-27 22:07:35', b'1');
INSERT INTO `oms_cart` VALUES (364527711, 4, 1135002, '1135002', '宫廷奢华真丝四件套', 204, 2599.00, 1, '[\"标准\"]', b'1', 'http://yanxuan.nosdn.127.net/45548f26cfd0c7c41e0afc3709d48286.png', '2023-05-31 16:03:21', '2023-05-31 20:54:38', b'1');
COMMIT;

-- ----------------------------
-- Table structure for oms_order
-- ----------------------------
DROP TABLE IF EXISTS `oms_order`;
CREATE TABLE `oms_order` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL COMMENT '用户表的用户ID',
  `order_sn` varchar(63) NOT NULL COMMENT '订单编号',
  `order_status` smallint(5) NOT NULL COMMENT '订单状态',
  `consignee` varchar(63) NOT NULL COMMENT '收货人名称',
  `mobile` varchar(63) NOT NULL COMMENT '收货人手机号',
  `address` varchar(127) NOT NULL COMMENT '收货具体地址',
  `message` varchar(512) NOT NULL COMMENT '用户订单留言',
  `goods_price` decimal(10,2) NOT NULL COMMENT '商品总费用',
  `freight_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '配送费用',
  `coupon_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '优惠券减免',
  `integral_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '用户积分减免',
  `groupon_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '团购优惠价减免',
  `order_price` decimal(10,2) NOT NULL COMMENT '订单费用， = goods_price + freight_price - coupon_price',
  `actual_price` decimal(10,2) NOT NULL COMMENT '实付费用， = order_price - integral_price',
  `pay_id` varchar(63) DEFAULT NULL COMMENT '微信付款编号',
  `pay_time` datetime DEFAULT NULL COMMENT '微信付款时间',
  `ship_sn` varchar(63) DEFAULT NULL COMMENT '发货编号',
  `ship_channel` varchar(63) DEFAULT NULL COMMENT '发货快递公司',
  `ship_time` datetime DEFAULT NULL COMMENT '发货开始时间',
  `confirm_time` datetime DEFAULT NULL COMMENT '用户确认收货时间',
  `comments` smallint(5) DEFAULT NULL COMMENT '待评价订单商品数量',
  `end_time` datetime DEFAULT NULL COMMENT '订单关闭时间',
  `add_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` bit(1) DEFAULT b'0' COMMENT '逻辑删除',
  `integration_amount` decimal(10,2) DEFAULT NULL COMMENT '积分抵扣金额',
  `integration` int(10) DEFAULT NULL COMMENT '可获得的积分',
  `growth` int(10) DEFAULT NULL COMMENT '成长值',
  `use_integration` int(10) DEFAULT NULL COMMENT '下单是使用的积分',
  `version` int(255) DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1203408901 DEFAULT CHARSET=utf8mb4 COMMENT='订单表';

-- ----------------------------
-- Records of oms_order
-- ----------------------------
BEGIN;
INSERT INTO `oms_order` VALUES (-1690677247, 4, 'fea98e4861084cd78e9ceb9f6d9603aa', 101, '陈强', '15613456827', '湖南省长沙市开福区四房小区1栋', '', 69.00, 8.00, 0.00, 0.00, 0.00, 77.00, 77.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2023-04-11 23:04:11', '2023-04-11 23:04:11', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (-1594179583, 4, '12d89bf27d2e4baeb75d2b226c0d38de', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2022-07-22 14:34:13', '2022-07-22 14:34:13', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (25, 4, '20201102277945', 103, '陈强', '15613456827', '湖南省长沙市开福区 四房小区1栋', '', 89.00, 0.00, 0.00, 0.00, 0.00, 89.00, 89.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2020-11-06 08:44:58', '2020-11-02 09:14:26', '2020-11-06 08:44:58', b'0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (26, 1, '20210130225788', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 1500.00, 0.00, 5.00, 0.00, 0.00, 1495.00, 1495.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (27, 1, '20210130655589', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 1500.00, 0.00, 5.00, 0.00, 0.00, 1495.00, 1495.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (28, 1, '20210130550589', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 1500.00, 0.00, 5.00, 0.00, 0.00, 1495.00, 1495.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (29, 1, '20210130567689', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 1500.00, 0.00, 5.00, 0.00, 0.00, 1495.00, 1495.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (30, 1, '20210130718970', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 1500.00, 0.00, 5.00, 0.00, 0.00, 1495.00, 1495.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (31, 1, '20210130536179', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 1500.00, 0.00, 5.00, 0.00, 0.00, 1495.00, 1495.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (32, 1, '20210130299870', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 1500.00, 0.00, 5.00, 0.00, 0.00, 1495.00, 1495.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (33, 1, '20210130654089', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 1500.00, 0.00, 5.00, 0.00, 0.00, 1495.00, 1495.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (34, 1, '20210130290872', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 1500.00, 0.00, 5.00, 0.00, 0.00, 1495.00, 1495.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (159, 4, '70617fe29fe1423d989a736a25193b48', 201, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-08 15:07:50', '2021-11-08 15:07:50', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (160, 4, '1a65d6a7429c4ff1b8f8fca2e6a8add3', 201, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-08 15:19:45', '2021-11-08 15:19:45', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (161, 4, 'f3484bd0aba04ccdae31ece26c265f10', 201, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-09 14:43:17', '2021-11-09 14:43:17', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (162, 4, 'af89f2c45c204afb8889ca8d43f25e38', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-09 15:07:09', '2021-11-09 15:07:09', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (163, 4, '49f4f112077e4e7a8f53f83ad34dd647', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-09 20:41:08', '2021-11-09 20:41:08', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (164, 4, '7a4577efb76542db8737bff96ff25036', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-09 20:52:38', '2021-11-09 20:52:38', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (165, 4, '5ca662800b5f48f9a0d48c59b26536e2', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-09 20:55:32', '2021-11-09 20:55:32', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (166, 4, '3dc7517e04b6491a8ee989a4817e3887', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-09 20:58:19', '2021-11-09 20:58:19', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (167, 4, '63b66640783449928d74ca7b04056c1f', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-09 21:50:04', '2021-11-09 21:50:04', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (168, 4, 'c1c1afdcdb43442eaacc284876072769', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-09 22:26:48', '2021-11-09 22:26:48', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (169, 4, '7edca12d5fe34c0f978c324184a06b53', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-09 23:09:41', '2021-11-09 23:09:41', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (170, 4, '2b5e13653f4d47fab8370c889e8fa379', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-09 23:15:07', '2021-11-09 23:15:07', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (171, 4, '33dc67950c5b492d87e5dd1bfc57eeaf', 201, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-09 23:20:56', '2021-11-09 23:20:56', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (172, 4, 'ddb7e2df04144cf59c2a205b0c4d3a51', 201, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-09 23:26:33', '2021-11-09 23:26:33', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (173, 4, '7687eea0634045fd9aaac358971235aa', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-10 08:50:48', '2021-11-10 08:50:48', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (174, 4, '9e28e43fc49b41e4a071a1152e9947a7', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-10 09:01:27', '2021-11-10 09:01:27', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (175, 4, 'e32c0fb1f683417b87c4e499ff4192ee', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-10 09:36:18', '2021-11-10 09:36:18', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (176, 4, '716988eb4e594fefb888aeb9d98982e9', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-10 09:53:04', '2021-11-10 09:53:04', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (177, 4, '5c6f7c91c76245c6ac418fbe7b0dc34e', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-10 10:01:25', '2021-11-10 10:01:25', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (178, 4, 'ce1df05cb22441a59c9dbd7b79500b9b', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-10 10:49:19', '2021-11-10 10:49:19', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (179, 4, '180f2bcf3f8a433d8ea8774b89a4a08f', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-10 14:54:11', '2021-11-10 14:54:11', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (180, 4, '9f49ff4188204c049191f0801c7c2be3', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-10 14:59:01', '2021-11-10 14:59:01', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (181, 4, 'f3daa516388c48c0846fcad675a9a7c6', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-10 15:04:19', '2021-11-10 15:04:19', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (182, 4, 'c90f5d6e4ab7489099bc1544f3dfd5b9', 102, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-10 15:08:45', '2021-11-10 15:08:45', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (183, 4, '825e344f3a6f4444ace93fa27f353560', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2022-07-22 14:39:43', '2022-07-22 14:39:43', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (184, 4, '0108c5e16df04c79b8cfbf3a70699e29', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2022-07-22 14:45:33', '2022-07-22 14:45:33', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (185, 4, '73064cc4cbeb4a309ce79fbef47e6f34', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2022-07-22 14:52:44', '2022-07-22 14:52:45', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (186, 4, 'b7bace9174db4487887c35ed43e38c6e', 101, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2022-07-22 15:01:11', '2022-07-22 15:01:11', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (187, 4, 'f932e89c91d04f6ca77b235c660f08a3', 201, '王大锤', '15612345678', '北京市市辖区东城区人间地狱小区11栋', '', 999.00, 0.00, 5.00, 0.00, 0.00, 999.00, 999.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2022-07-22 15:06:52', '2022-07-22 15:06:52', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (649760769, 4, 'a9d13b0ca8f4413f87016f9ff7e138c8', 101, '陈强', '15613456827', '湖南省长沙市开福区四房小区1栋', '', 69.00, 8.00, 0.00, 0.00, 0.00, 77.00, 77.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2023-04-11 23:20:16', '2023-04-11 23:20:16', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (679120897, 4, '7492c7d3cad24b2ab4eee67ad41d8a3d', 101, '陈强', '15613456827', '湖南省长沙市开福区四房小区1栋', '', 69.00, 8.00, 0.00, 0.00, 0.00, 77.00, 77.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2023-04-11 23:28:08', '2023-04-11 23:28:08', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (695894018, 4, '783ed80650ff428d94bd68e22e376b3b', 101, '陈强', '15613456827', '湖南省长沙市开福区四房小区1栋', '', 69.00, 8.00, 0.00, 0.00, 0.00, 77.00, 77.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2023-04-11 22:57:04', '2023-04-11 22:57:04', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (1203408897, 4, '2a5745af7add4c7baab18b47de6b8eb3', 101, '陈强', '15613456827', '湖南省长沙市开福区四房小区1栋', '', 69.00, 8.00, 0.00, 0.00, 0.00, 77.00, 77.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2023-04-11 23:25:25', '2023-04-11 23:25:25', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (1203408898, 4, '4e013cd36a4d47f8ab350a226bf30cf1', 201, '陈强', '15613456827', '湖南省长沙市开福区四房小区1栋', '', 2599.00, 0.00, 0.00, 0.00, 0.00, 2599.00, 2599.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2023-05-27 12:14:12', '2023-05-27 12:14:12', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (1203408899, 4, '2e8a6635cd6b427baf891b1b467d72d3', 201, '陈强', '15613456827', '湖南省长沙市开福区四房小区1栋', '', 2599.00, 0.00, 0.00, 0.00, 0.00, 2599.00, 2599.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2023-05-27 22:07:47', '2023-05-27 22:07:47', b'0', NULL, NULL, NULL, NULL, 0);
INSERT INTO `oms_order` VALUES (1203408900, 4, '19fb54cfb6d34b0bbe8b7f634c1c9858', 201, '陈强', '15613456827', '湖南省长沙市开福区四房小区1栋', '', 2599.00, 0.00, 0.00, 0.00, 0.00, 2599.00, 2599.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2023-05-31 20:56:17', '2023-05-31 20:56:17', b'0', NULL, NULL, NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for oms_order_goods
-- ----------------------------
DROP TABLE IF EXISTS `oms_order_goods`;
CREATE TABLE `oms_order_goods` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `order_id` int(10) NOT NULL COMMENT '订单表的订单ID',
  `goods_id` int(10) NOT NULL COMMENT '商品表的商品ID',
  `goods_name` varchar(127) NOT NULL COMMENT '商品名称',
  `goods_sn` varchar(63) NOT NULL COMMENT '商品编号',
  `product_id` int(10) NOT NULL COMMENT '商品货品表的货品ID',
  `number` smallint(5) NOT NULL COMMENT '商品货品的购买数量',
  `price` decimal(10,2) NOT NULL COMMENT '商品货品的售价',
  `specifications` varchar(1023) NOT NULL COMMENT '商品货品的规格列表',
  `pic_url` varchar(255) NOT NULL COMMENT '商品货品图片或者商品图片',
  `comment` int(10) DEFAULT NULL COMMENT '订单商品评论，如果是-1，则超期不能评价；如果是0，则可以评价；如果其他值，则是comment表里面的评论ID。',
  `add_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` bit(1) DEFAULT b'0' COMMENT '逻辑删除',
  `integration_amount` decimal(10,2) DEFAULT NULL COMMENT '积分优惠分解金额',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=utf8mb4 COMMENT='订单商品表';

-- ----------------------------
-- Records of oms_order_goods
-- ----------------------------
BEGIN;
INSERT INTO `oms_order_goods` VALUES (-415555582, 1203408898, 1135002, '宫廷奢华真丝四件套', '1135002', 204, 1, 2599.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/45548f26cfd0c7c41e0afc3709d48286.png', NULL, '2023-05-27 12:14:12', '2023-05-27 12:14:12', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (-298151935, 1203408900, 1135002, '宫廷奢华真丝四件套', '1135002', 204, 1, 2599.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/45548f26cfd0c7c41e0afc3709d48286.png', NULL, '2023-05-31 20:56:17', '2023-05-31 20:56:17', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (-285573119, 1203408899, 1135002, '宫廷奢华真丝四件套', '1135002', 204, 1, 2599.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/45548f26cfd0c7c41e0afc3709d48286.png', NULL, '2023-05-27 22:07:47', '2023-05-27 22:07:47', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (1, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', 0, '2020-06-27 18:46:57', '2020-06-27 18:46:57', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (2, 2, 1039051, '多功能午睡枕', '1039051', 54, 1, 79.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/c8ca0600fa7ba11ca8be6a3173dd38c9.png', 0, '2020-07-01 20:55:04', '2020-07-01 20:55:04', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (3, 3, 1181001, '新梦想睡枕', '1001991', 248, 1, 10.00, '[\"红色\",\"1.5\"]', 'https://app-newdream-1302590708.cos.ap-shanghai.myqcloud.com/ovwr2niit6a9jrp7xurn.png', 0, '2020-07-08 11:42:49', '2020-07-08 11:42:49', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (4, 4, 1130037, '帆布丝羽绒多用坐垫', '1130037', 189, 3, 39.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/19ecd7c6f6f31219cf75117238d95139.png', 0, '2020-07-21 11:38:47', '2020-07-21 11:38:47', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (5, 5, 1181001, '新梦想睡枕', '1001991', 247, 1, 89.00, '[\"红色\",\"1.8M\"]', 'https://app-newdream-1302590708.cos.ap-shanghai.myqcloud.com/ovwr2niit6a9jrp7xurn.png', 0, '2020-07-21 16:37:52', '2020-07-21 16:37:52', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (6, 6, 1057036, '日式纯色水洗亚麻抱枕', '1057036', 71, 1, 79.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/8a9ee5ba08929cc9e40b973607d2f633.png', 0, '2020-07-21 16:40:41', '2020-07-21 16:40:41', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (7, 7, 1057036, '日式纯色水洗亚麻抱枕', '1057036', 71, 1, 79.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/8a9ee5ba08929cc9e40b973607d2f633.png', 0, '2020-07-21 16:42:34', '2020-07-21 16:42:34', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (8, 8, 1181001, '新梦想睡枕', '1001991', 248, 1, 10.00, '[\"红色\",\"1.5\"]', 'https://app-newdream-1302590708.cos.ap-shanghai.myqcloud.com/ovwr2niit6a9jrp7xurn.png', 0, '2020-07-23 17:00:19', '2020-07-23 17:00:19', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (9, 9, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', 0, '2020-07-23 17:03:22', '2020-07-23 17:03:22', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (10, 10, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', 0, '2020-07-23 17:05:19', '2020-07-23 17:05:19', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (11, 11, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', 0, '2020-07-23 17:12:16', '2020-07-23 17:12:16', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (12, 12, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 5, 1, 2000.00, '[\"1.8m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', 0, '2020-07-23 17:16:09', '2020-07-23 17:16:09', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (13, 13, 1064006, '3D纯棉护颈加翼记忆枕', '1064006', 76, 1, 129.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/35306b8e65932dd28a5628d0bb44a044.png', 0, '2020-07-31 11:52:59', '2020-07-31 11:52:59', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (14, 14, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 3, 1, 1000.00, '[\"1.5m床垫*1+枕头*2\",\"烟白灰\"]', 'http://yanxuan.nosdn.127.net/36f64a7161b67e7fb8ea45be32ecfa25.png?quality=90&thumbnail=200x200&imageView', 0, '2020-07-31 15:10:17', '2020-07-31 15:10:17', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (15, 15, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', 0, '2020-07-31 15:50:35', '2020-07-31 15:50:35', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (16, 16, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', 0, '2020-07-31 15:53:10', '2020-07-31 15:53:10', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (17, 17, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', 0, '2020-07-31 15:55:02', '2020-07-31 15:55:02', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (18, 18, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', 0, '2020-07-31 15:55:16', '2020-07-31 15:55:16', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (19, 19, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', 0, '2020-07-31 15:55:19', '2020-07-31 15:55:19', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (20, 20, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', 0, '2020-07-31 15:55:39', '2020-07-31 15:55:39', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (21, 21, 1086015, '北欧极简直杆台灯', '1086015', 103, 1, 249.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/d5c2ecfe0fb00cdd8b829975bab21a31.png', 0, '2020-07-31 16:38:40', '2020-07-31 16:38:40', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (22, 22, 1109008, '云端沙发组合', '1109008', 140, 1, 3999.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/c5be2604c0e4186a4e7079feeb742cee.png', 0, '2020-08-12 17:53:37', '2020-08-12 17:53:37', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (23, 23, 1086015, '北欧极简直杆台灯', '1086015', 103, 1, 249.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/d5c2ecfe0fb00cdd8b829975bab21a31.png', 0, '2020-10-31 23:35:12', '2020-10-31 23:35:12', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (24, 24, 1181001, '新梦想睡枕22', '1001991', 263, 1, 89.00, '[\"红色\",\"1.8M\"]', 'https://app-newdream-1302590708.cos.ap-shanghai.myqcloud.com/ovwr2niit6a9jrp7xurn.png', 0, '2020-11-02 09:14:18', '2020-11-02 09:14:18', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (25, 25, 1181001, '新梦想睡枕22', '1001991', 263, 1, 89.00, '[\"红色\",\"1.8M\"]', 'https://app-newdream-1302590708.cos.ap-shanghai.myqcloud.com/ovwr2niit6a9jrp7xurn.png', 0, '2020-11-02 09:14:26', '2020-11-02 09:14:26', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (26, 26, 1064006, '3D纯棉护颈加翼记忆枕', '1064006', 76, 1, 129.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/35306b8e65932dd28a5628d0bb44a044.png', 0, '2020-11-02 09:14:43', '2020-11-02 09:14:43', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (27, 27, 1057036, '日式纯色水洗亚麻抱枕', '1057036', 71, 1, 79.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/8a9ee5ba08929cc9e40b973607d2f633.png', 0, '2020-11-02 09:15:58', '2020-11-02 09:15:58', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (28, 28, 1023003, '100年传世珐琅锅 全家系列', '1023003', 33, 1, 398.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/c39d54c06a71b4b61b6092a0d31f2335.png', 0, '2020-11-02 09:16:41', '2020-11-02 09:16:41', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (29, 29, 1023003, '100年传世珐琅锅 全家系列', '1023003', 33, 1, 398.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/c39d54c06a71b4b61b6092a0d31f2335.png', 0, '2020-11-02 09:16:44', '2020-11-02 09:16:44', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (30, 30, 1046044, '美利奴羊毛盖毯设计师款', '1046044', 61, 1, 349.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/2bfecfe58ea3ee0d554f2ed58e9ba30a.png', 0, '2020-11-19 09:50:39', '2020-11-19 09:50:39', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (31, 31, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', 0, '2020-11-19 10:02:48', '2020-11-19 10:02:48', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (32, 26, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-01-30 13:01:18', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (33, 27, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-01-30 13:24:13', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (34, 28, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-01-30 13:30:28', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (35, 29, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-01-30 13:32:32', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (36, 30, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-01-30 13:34:02', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (37, 31, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-01-30 13:38:08', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (38, 32, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-01-30 13:41:10', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (39, 33, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-01-30 13:42:38', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (40, 34, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-01-30 14:18:38', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (41, 35, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-01-30 14:20:07', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (42, 36, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-02-02 09:30:07', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (43, 37, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-02-02 09:34:26', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (44, 38, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-02-02 09:47:52', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (45, 39, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-02-02 09:48:51', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (46, 40, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-02-02 10:28:23', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (47, 41, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-02-02 10:38:00', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (48, 42, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-02-02 21:26:20', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (49, 43, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-02-02 21:42:35', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (50, 44, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-02-27 19:09:18', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (51, 45, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-02-27 19:15:55', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (52, 46, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-02-27 19:16:42', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (53, 47, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 18:34:20', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (54, 48, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 18:55:48', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (55, 49, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 21:28:00', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (56, 50, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 21:35:38', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (57, 51, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 21:50:13', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (58, 52, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 22:01:17', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (59, 53, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 22:07:59', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (60, 54, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 22:16:56', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (61, 55, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 22:23:05', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (62, 56, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 22:25:05', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (63, 57, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 22:26:08', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (64, 58, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 22:26:51', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (65, 59, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 22:32:16', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (66, 60, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 2, 1, 1500.00, '[\"1.5m床垫*1+枕头*2\",\"玛瑙红\"]', 'quality=90&thumbnail=200x200&imageView', NULL, '2021-03-01 22:38:44', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (67, 62, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-08-19 23:16:16', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (68, 63, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-08-20 16:33:10', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (69, 64, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-08-20 16:39:29', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (70, 65, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-08-20 16:43:46', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (71, 66, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-08-20 21:53:46', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (72, 67, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-08-20 22:02:11', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (73, 68, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-08-20 22:20:16', NULL, NULL, NULL);
INSERT INTO `oms_order_goods` VALUES (74, 69, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-08-20 22:27:42', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (75, 70, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-08-20 22:39:53', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (76, 71, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-08-23 08:58:13', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (77, 72, 1127047, '趣味粉彩系列笔记本', '1127047', 182, 1, 29.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/6c03ca93d8fe404faa266ea86f3f1e43.png', NULL, '2021-08-26 22:24:01', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (78, 73, 1006007, '秋冬保暖加厚澳洲羊毛被', '1006007', 8, 1, 459.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/66425d1ed50b3968fed27c822fdd32e0.png', NULL, '2021-08-26 22:32:59', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (79, 74, 1006013, '双宫茧桑蚕丝被 空调被', '1006013', 10, 1, 699.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/583812520c68ca7995b6fac4c67ae2c7.png', NULL, '2021-08-27 14:20:54', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (80, 75, 1006013, '双宫茧桑蚕丝被 空调被', '1006013', 10, 1, 699.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/583812520c68ca7995b6fac4c67ae2c7.png', NULL, '2021-08-27 14:22:03', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (81, 76, 1181001, '新梦想睡枕22', '1001991', 264, 1, 10.00, '[\"红色\",\"1.5\"]', 'https://app-newdream-1302590708.cos.ap-shanghai.myqcloud.com/ovwr2niit6a9jrp7xurn.png', NULL, '2021-08-27 14:36:18', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (82, 77, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-27 15:00:01', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (83, 78, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-27 15:07:15', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (84, 79, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-27 15:44:57', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (85, 80, 1009012, '可水洗舒柔丝羽绒枕', '1009012', 14, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/a196b367f23ccfd8205b6da647c62b84.png', NULL, '2021-08-27 16:53:00', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (86, 81, 1006013, '双宫茧桑蚕丝被 空调被', '1006013', 10, 1, 699.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/583812520c68ca7995b6fac4c67ae2c7.png', NULL, '2021-08-29 13:19:31', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (87, 82, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-29 14:10:58', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (88, 83, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-29 14:13:29', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (89, 84, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-29 14:16:19', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (90, 85, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-29 14:20:59', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (91, 86, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-29 17:11:13', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (92, 87, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-29 17:15:33', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (93, 88, 1009012, '可水洗舒柔丝羽绒枕', '1009012', 14, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/a196b367f23ccfd8205b6da647c62b84.png', NULL, '2021-08-29 17:36:03', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (94, 89, 1009012, '可水洗舒柔丝羽绒枕', '1009012', 14, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/a196b367f23ccfd8205b6da647c62b84.png', NULL, '2021-08-30 11:36:43', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (95, 90, 1127047, '趣味粉彩系列笔记本', '1127047', 182, 1, 29.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/6c03ca93d8fe404faa266ea86f3f1e43.png', NULL, '2021-08-30 22:14:53', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (96, 91, 1127047, '趣味粉彩系列笔记本', '1127047', 182, 1, 29.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/6c03ca93d8fe404faa266ea86f3f1e43.png', NULL, '2021-08-30 22:38:59', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (97, 92, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-30 22:42:29', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (98, 93, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-30 22:47:03', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (99, 94, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 12:35:49', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (100, 95, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 12:41:35', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (101, 96, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 12:43:44', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (102, 97, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 12:45:28', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (103, 98, 1006013, '双宫茧桑蚕丝被 空调被', '1006013', 10, 1, 699.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/583812520c68ca7995b6fac4c67ae2c7.png', NULL, '2021-08-31 12:53:22', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (104, 99, 1006013, '双宫茧桑蚕丝被 空调被', '1006013', 10, 1, 699.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/583812520c68ca7995b6fac4c67ae2c7.png', NULL, '2021-08-31 12:53:43', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (105, 100, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 14:48:05', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (106, 101, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 14:48:26', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (107, 102, 1127047, '趣味粉彩系列笔记本', '1127047', 182, 1, 29.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/6c03ca93d8fe404faa266ea86f3f1e43.png', NULL, '2021-08-31 14:53:12', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (108, 103, 1127047, '趣味粉彩系列笔记本', '1127047', 182, 1, 29.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/6c03ca93d8fe404faa266ea86f3f1e43.png', NULL, '2021-08-31 14:53:24', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (109, 104, 1127047, '趣味粉彩系列笔记本', '1127047', 182, 1, 29.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/6c03ca93d8fe404faa266ea86f3f1e43.png', NULL, '2021-08-31 14:57:01', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (110, 105, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 15:05:18', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (111, 106, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 15:05:50', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (112, 107, 1009012, '可水洗舒柔丝羽绒枕', '1009012', 14, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/a196b367f23ccfd8205b6da647c62b84.png', NULL, '2021-08-31 22:51:36', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (113, 108, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 23:05:07', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (114, 109, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 23:13:14', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (115, 110, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 23:21:49', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (116, 111, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 23:26:17', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (117, 112, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 23:26:46', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (118, 113, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-08-31 23:27:35', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (119, 114, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-09-01 14:44:55', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (120, 115, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-09-01 14:51:05', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (121, 116, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-09-02 15:13:49', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (122, 117, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-09-02 15:16:26', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (123, 118, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-09-02 15:33:52', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (130, 125, 1006051, '皇室御用超柔毛巾', '1006051', 12, 1, 59.00, '[\"标准\"]', 'http://yanxuan.nosdn.127.net/ad5a317216f9da495b144070ecf1f957.png', NULL, '2021-09-02 17:40:37', NULL, b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (131, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-04 18:45:01', '2021-11-04 18:45:01', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (132, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-04 18:45:17', '2021-11-04 18:45:17', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (133, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-04 18:48:52', '2021-11-04 18:48:52', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (134, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-04 18:48:54', '2021-11-04 18:48:54', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (135, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-04 18:48:56', '2021-11-04 18:48:56', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (136, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-04 18:48:57', '2021-11-04 18:48:57', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (137, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-04 18:48:58', '2021-11-04 18:48:58', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (138, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-04 18:49:18', '2021-11-04 18:49:18', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (139, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-04 18:49:59', '2021-11-04 18:49:59', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (140, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-04 18:52:51', '2021-11-04 18:52:51', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (141, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-04 18:56:30', '2021-11-04 18:56:30', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (142, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-05 09:43:13', '2021-11-05 09:43:13', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (143, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-05 09:44:20', '2021-11-05 09:44:20', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (144, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-05 14:21:24', '2021-11-05 14:21:24', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (145, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-05 22:21:27', '2021-11-05 22:21:27', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (146, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-05 22:38:27', '2021-11-05 22:38:27', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (147, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-05 23:02:08', '2021-11-05 23:02:08', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (148, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-05 23:12:41', '2021-11-05 23:12:41', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (149, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-05 23:22:28', '2021-11-05 23:22:28', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (150, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-05 23:40:42', '2021-11-05 23:40:42', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (151, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-08 08:50:07', '2021-11-08 08:50:07', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (152, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-08 08:56:50', '2021-11-08 08:56:50', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (153, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-08 09:03:15', '2021-11-08 09:03:15', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (154, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-08 09:08:27', '2021-11-08 09:08:27', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (155, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-08 09:12:29', '2021-11-08 09:12:29', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (156, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-08 09:15:21', '2021-11-08 09:15:21', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (157, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-08 09:23:07', '2021-11-08 09:23:07', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (158, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-08 09:32:45', '2021-11-08 09:32:45', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (159, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-08 09:41:54', '2021-11-08 09:41:54', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (164, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-08 15:07:50', '2021-11-08 15:07:50', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (165, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-08 15:19:46', '2021-11-08 15:19:46', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (166, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-09 14:43:18', '2021-11-09 14:43:18', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (167, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-09 15:07:10', '2021-11-09 15:07:10', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (168, 1, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-09 20:41:09', '2021-11-09 20:41:09', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (169, 164, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-09 20:52:38', '2021-11-09 20:52:38', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (170, 165, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-09 20:55:32', '2021-11-09 20:55:32', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (171, 166, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-09 20:58:19', '2021-11-09 20:58:19', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (172, 167, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-09 21:50:04', '2021-11-09 21:50:04', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (173, 168, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-09 22:26:48', '2021-11-09 22:26:48', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (174, 169, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-09 23:09:41', '2021-11-09 23:09:41', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (175, 170, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-09 23:15:07', '2021-11-09 23:15:07', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (176, 171, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-09 23:20:56', '2021-11-09 23:20:56', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (177, 172, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-09 23:26:33', '2021-11-09 23:26:33', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (178, 173, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-10 08:50:48', '2021-11-10 08:50:48', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (179, 174, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-10 09:01:27', '2021-11-10 09:01:27', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (180, 175, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-10 09:36:18', '2021-11-10 09:36:18', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (181, 176, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-10 09:53:04', '2021-11-10 09:53:04', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (182, 177, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-10 10:01:25', '2021-11-10 10:01:25', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (183, 178, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-10 10:49:21', '2021-11-10 10:49:21', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (184, 179, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-10 14:54:11', '2021-11-10 14:54:11', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (185, 180, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-10 14:59:01', '2021-11-10 14:59:01', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (186, 181, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-10 15:04:19', '2021-11-10 15:04:19', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (187, 182, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2021-11-10 15:08:45', '2021-11-10 15:08:45', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (188, 186, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2022-07-22 15:01:11', '2022-07-22 15:01:11', b'0', NULL);
INSERT INTO `oms_order_goods` VALUES (189, 187, 1181000, '母亲节礼物-舒适安睡组合', '1181000', 1, 1, 999.00, '[\"1.5m床垫*1+枕头*2\",\"浅杏粉\"]', 'http://yanxuan.nosdn.127.net/1f67b1970ee20fd572b7202da0ff705d.png', NULL, '2022-07-22 15:06:52', '2022-07-22 15:06:52', b'0', NULL);
COMMIT;

-- ----------------------------
-- Table structure for oms_order_operate_history
-- ----------------------------
DROP TABLE IF EXISTS `oms_order_operate_history`;
CREATE TABLE `oms_order_operate_history` (
  `id` bigint(19) NOT NULL AUTO_INCREMENT,
  `order_id` bigint(19) DEFAULT NULL COMMENT '订单id',
  `operate_man` varchar(100) DEFAULT NULL COMMENT '操作人：用户；系统；后台管理员',
  `create_time` datetime DEFAULT NULL COMMENT '操作时间',
  `order_status` int(10) DEFAULT NULL COMMENT '订单状态：0->待付款；1->待发货；2->已发货；3->已完成；4->已关闭；5->无效订单',
  `note` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单操作历史记录';

-- ----------------------------
-- Table structure for oms_order_return_apply
-- ----------------------------
DROP TABLE IF EXISTS `oms_order_return_apply`;
CREATE TABLE `oms_order_return_apply` (
  `id` bigint(19) NOT NULL AUTO_INCREMENT,
  `order_id` bigint(19) DEFAULT NULL COMMENT '订单id',
  `company_address_id` bigint(19) DEFAULT NULL COMMENT '收货地址表id',
  `product_id` bigint(19) DEFAULT NULL COMMENT '退货商品id',
  `order_sn` varchar(64) DEFAULT NULL COMMENT '订单编号',
  `create_time` datetime DEFAULT NULL COMMENT '申请时间',
  `member_username` varchar(64) DEFAULT NULL COMMENT '会员用户名',
  `return_amount` decimal(10,2) DEFAULT NULL COMMENT '退款金额',
  `return_name` varchar(100) DEFAULT NULL COMMENT '退货人姓名',
  `return_phone` varchar(100) DEFAULT NULL COMMENT '退货人电话',
  `status` int(10) DEFAULT NULL COMMENT '申请状态：0->待处理；1->退货中；2->已完成；3->已拒绝',
  `handle_time` datetime DEFAULT NULL COMMENT '处理时间',
  `product_pic` varchar(500) DEFAULT NULL COMMENT '商品图片',
  `product_name` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `product_brand` varchar(200) DEFAULT NULL COMMENT '商品品牌',
  `product_attr` varchar(500) DEFAULT NULL COMMENT '商品销售属性：颜色：红色；尺码：xl;',
  `product_count` int(10) DEFAULT NULL COMMENT '退货数量',
  `product_price` decimal(10,2) DEFAULT NULL COMMENT '商品单价',
  `product_real_price` decimal(10,2) DEFAULT NULL COMMENT '商品实际支付单价',
  `reason` varchar(200) DEFAULT NULL COMMENT '原因',
  `description` varchar(500) DEFAULT NULL COMMENT '描述',
  `proof_pics` varchar(1000) DEFAULT NULL COMMENT '凭证图片，以逗号隔开',
  `handle_note` varchar(500) DEFAULT NULL COMMENT '处理备注',
  `handle_man` varchar(100) DEFAULT NULL COMMENT '处理人员',
  `receive_man` varchar(100) DEFAULT NULL COMMENT '收货人',
  `receive_time` datetime DEFAULT NULL COMMENT '收货时间',
  `receive_note` varchar(500) DEFAULT NULL COMMENT '收货备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单退货申请';

-- ----------------------------
-- Table structure for oms_order_return_reason
-- ----------------------------
DROP TABLE IF EXISTS `oms_order_return_reason`;
CREATE TABLE `oms_order_return_reason` (
  `id` bigint(19) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL COMMENT '退货类型',
  `sort` int(10) DEFAULT NULL,
  `status` int(10) DEFAULT NULL COMMENT '状态：0->不启用；1->启用',
  `create_time` datetime DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='退货原因表';

-- ----------------------------
-- Table structure for oms_order_setting
-- ----------------------------
DROP TABLE IF EXISTS `oms_order_setting`;
CREATE TABLE `oms_order_setting` (
  `id` bigint(19) NOT NULL AUTO_INCREMENT,
  `flash_order_overtime` int(10) DEFAULT NULL COMMENT '秒杀订单超时关闭时间(分)',
  `normal_order_overtime` int(10) DEFAULT NULL COMMENT '正常订单超时时间(分)',
  `confirm_overtime` int(10) DEFAULT NULL COMMENT '发货后自动确认收货时间（天）',
  `finish_overtime` int(10) DEFAULT NULL COMMENT '自动完成交易时间，不能申请售后（天）',
  `comment_overtime` int(10) DEFAULT NULL COMMENT '订单完成后自动好评时间（天）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单设置表';

-- ----------------------------
-- Table structure for oms_payment_info
-- ----------------------------
DROP TABLE IF EXISTS `oms_payment_info`;
CREATE TABLE `oms_payment_info` (
  `id` bigint(19) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `order_sn` char(32) DEFAULT NULL COMMENT '订单号（对外业务号）',
  `order_id` bigint(19) DEFAULT NULL COMMENT '订单id',
  `alipay_trade_no` varchar(50) DEFAULT NULL COMMENT '支付宝交易流水号',
  `total_amount` decimal(18,4) DEFAULT NULL COMMENT '支付总金额',
  `subject` varchar(200) DEFAULT NULL COMMENT '交易内容',
  `payment_status` varchar(20) DEFAULT NULL COMMENT '支付状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `confirm_time` datetime DEFAULT NULL COMMENT '确认时间',
  `callback_content` varchar(4000) DEFAULT NULL COMMENT '回调内容',
  `callback_time` datetime DEFAULT NULL COMMENT '回调时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付信息表';

-- ----------------------------
-- Table structure for oms_refund_info
-- ----------------------------
DROP TABLE IF EXISTS `oms_refund_info`;
CREATE TABLE `oms_refund_info` (
  `id` bigint(19) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `order_return_id` bigint(19) DEFAULT NULL COMMENT '退款的订单',
  `refund` decimal(18,4) DEFAULT NULL COMMENT '退款金额',
  `refund_sn` varchar(64) DEFAULT NULL COMMENT '退款交易流水号',
  `refund_status` bit(1) DEFAULT NULL COMMENT '退款状态',
  `refund_channel` tinyint(3) DEFAULT NULL COMMENT '退款渠道[1-支付宝，2-微信，3-银联，4-汇款]',
  `refund_content` varchar(5000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='退款信息';

-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) NOT NULL,
  `xid` varchar(100) NOT NULL,
  `context` varchar(128) NOT NULL,
  `rollback_info` longblob NOT NULL,
  `log_status` int(11) NOT NULL,
  `log_created` datetime NOT NULL,
  `log_modified` datetime NOT NULL,
  `ext` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;
